﻿IF EXISTS (SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_TYPE = 'PROCEDURE' AND ROUTINE_NAME = 'OTGetList')
	BEGIN
		DROP  Procedure  OTGetList
	END
GO

CREATE PROCEDURE OTGetList
AS
BEGIN	
	SET NOCOUNT ON

	SELECT Id, NumeroOT AS Nombre 
	FROM lit_ot
	
	SET NOCOUNT OFF
END

GO 